求excel高手,IF函数嵌套,小于100为差,大于等于100为中,大于等于500为...答:假设数据写在A1单元格,则公式为 =IF(A1="","",IF(A1<100,"差",IF(A1<500,"中",IF(A1<1000,"良",IF(A1<3000,"优","卓越")))或 =IF(A1="","",LOOKUP(A1,{0,"差";100,"中";500,"良";1000,"优";3000,"卓越"}))...
为什么Excel中if函数我写的大于小于这种全都无法判断?答:IF(0<=N6/D6<0.1,0,"")0<=N6/D6<0.1这种表达方式,EXCEL不能理解成你想要的。应该修改为AND(N6/D6>=0,N6/D6<0.1)才能被EXCEL正确理解。=IF(OR(N6/D6>1,N6/D6<0.1),"",IF(N6/D6=1,1,IF(N6/D6>=0.9,0.8,IF(N6/D6>=0.6,0.6,IF(N6/D6>=0.1,0.1,""...